﻿CREATE TABLE [dbo].[DatabaseInstances] (
    [Computer Name]                       VARCHAR (255) NULL,
    [SQL Server Instance Name]            VARCHAR (255) NULL,
    [SQL Server Product Name]             VARCHAR (255) NULL,
    [SQL Server Version]                  VARCHAR (255) NULL,
    [SQL Server Service Pack]             VARCHAR (255) NULL,
    [SQL Server Edition]                  VARCHAR (255) NULL,
    [Clustered?]                          VARCHAR (255) NULL,
    [SQL Server Cluster Network Name]     VARCHAR (255) NULL,
    [SQL Service State]                   VARCHAR (255) NULL,
    [SQL Service Start Mode]              VARCHAR (255) NULL,
    [Language]                            VARCHAR (255) NULL,
    [SQL Server Sub-Directory]            VARCHAR (255) NULL,
    [Current Operating System]            VARCHAR (255) NULL,
    [Operating System Service Pack Level] VARCHAR (255) NULL,
    [Operating System Architecture Type]  VARCHAR (255) NULL,
    [Number of Processors]                VARCHAR (255) NULL,
    [Number of Total Cores]               VARCHAR (255) NULL,
    [Number of Logical Processors]        VARCHAR (255) NULL,
    [CPU]                                 VARCHAR (255) NULL,
    [System Memory (MB)]                  VARCHAR (255) NULL,
    [Logical Disk Drive Name]             VARCHAR (255) NULL,
    [Logical Disk Size (GB)]              VARCHAR (255) NULL,
    [Logical Disk Free Space (GB)]        VARCHAR (255) NULL,
    [Machine Type]                        VARCHAR (255) NULL,
    [Number of Host Processors]           VARCHAR (255) NULL,
    [WMI Status]                          VARCHAR (255) NULL,
    [Environment]                         VARCHAR (255) NULL,
    [VM Host]                             VARCHAR (255) NULL,
    [License Type]                        VARCHAR (255) NULL,
    [License Priorty]                     VARCHAR (255) NULL,
    [Product Version]                     VARCHAR (255) NULL,
    [Product Name]                        VARCHAR (255) NULL,
    [Product Priority]                    VARCHAR (255) NULL,
    [Same Machine]                        VARCHAR (255) NULL,
    [Calculated Proc Multiplier]          VARCHAR (255) NULL,
    [Proc Multiplier]                     VARCHAR (255) NULL,
    [Cores Based on Proc Type]            VARCHAR (255) NULL,
    [SQL RTM]                             VARCHAR (255) NULL,
    [SQL SP1]                             VARCHAR (255) NULL,
    [SQL SP2]                             VARCHAR (255) NULL,
    [SQL SP3]                             VARCHAR (255) NULL,
    [SQL SP4]                             VARCHAR (255) NULL,
    [Win RTM]                             VARCHAR (255) NULL,
    [Win SP1]                             VARCHAR (255) NULL,
    [Win SP2]                             VARCHAR (255) NULL,
    [Win SP3]                             VARCHAR (255) NULL,
    [Win SP4]                             VARCHAR (255) NULL,
    [Edition]                             VARCHAR (255) NULL,
    [Adjusted Cores]                      VARCHAR (255) NULL,
    [Contributing Procs ]                 VARCHAR (255) NULL,
    [Contributing Cores]                  VARCHAR (255) NULL,
    [Core Grants]                         VARCHAR (255) NULL,
    [License Cores]                       VARCHAR (255) NULL,
    [ExceedsEnterpriseCap]                VARCHAR (255) NULL,
    [ExceedsStandardCap]                  VARCHAR (255) NULL,
    [ExceedsCoreGrant]                    VARCHAR (255) NULL,
    [Requires Attention]                  VARCHAR (255) NULL,
    [Cluster]                             VARCHAR (255) NULL,
    [Operating System]                    VARCHAR (255) NULL,
    [Operating System Edition]            VARCHAR (255) NULL
);

